﻿USE KwaiXiaoDianDB;
GO


--商品信息表添加上架达人数和月销量等字段
if not exists(select * from syscolumns where id=object_id('t_product') and name='promoter_num')
begin
	ALTER TABLE dbo.t_product ADD promoter_num INT NULL;
END
GO

if not exists(select * from syscolumns where id=object_id('t_product') and name='sold_count_thirty_days')
begin
	ALTER TABLE dbo.t_product ADD sold_count_thirty_days INT NULL;
END
go